<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<?php
include "connectDB.php";

$res = mysql_query("SELECT * FROM clan ORDER BY clan DESC")
or die("Invalid query: " . mysql_query());
echo '<label>Select value:</label>';
echo '<select id="clan_id" name="clan">';
echo '<option clan_id="">Select</option>';

while ($row = mysql_fetch_assoc($res)) {
$va = $row['clan'];
echo "<option value='$va'>$va</option>";
}
echo '</select>';
?>

</body>
</html>
